import xlwings as xw
app = xw.App(visible=False, add_book=False)
workbook = app.books.open('F:\\python\\第4章\\汽车备案信息.xlsx')
worksheet = workbook.sheets['商用车信息']
rng = worksheet.range('A10:D20')
addr1 = rng.address
addr2 = rng.get_address(row_absolute=False, column_absolute=False)
addr3 = rng.get_address(row_absolute=True, column_absolute=False)
addr4 = rng.get_address(include_sheetname=True)
addr5 = rng.get_address(external=True)
print(addr1, addr2, addr3)
print(addr4)
print(addr5)
workbook.close()
app.quit()
